﻿
CREATE PROCEDURE [dbo].[proc_Company_GetItem]
	(
		@Id int
	)
AS
	Select Company.Id, CompanyName,Startletter,CompanyNumber,CompanyPhone,CompanyFax,CompanyAddress,Zip,
	ContactPerson,ContactPhone,ContactEmail,WebAddress,Products,CompanyAllName,isnull(Mid,0) AS mid,
	companyFR,createdate,zzjg.bh AS dwbh
	  From Company,zzjg Where Company.Id=@Id AND zzjg.CompanyId=Company.Id
	RETURN

